Excel Charts

The M&M Company counted the M&M’s in 6 individual packages of M&M’s and obtained the following results:

 

 

brown

yellow

orange

 red

green

blue

Total

Bag 1

22

8

5

11

5

3

Bag 2

12

9

9

13

6

4

Bag 3

12

12

5

15

6

5

Bag 4

11

10

4

12

8

5

Bag 5

19

7

6

14

5

4

Bag 6

13

10

9

8

11

6

  1. Copy the information from the above chart into an Excel Spreadsheet.
  2. Be sure all charts has a title and axes titles.
  3. Create a column chart using the colors for bag 1 and 3.
  4. Create a line chart using the total number of m&m's in all bags.
  5. Create a pie chart using the colors of bag 5.
  6. Be sure all charts are on one sheet and labeled M&Ms

Create a sheet in the same Excel file for a 24 hour typical school day including minutes spent sleeping, eating, at school, with friends, watching videos, etc. Then, create a Pie Chart and label sheet as School Day.

Create a third sheet and label it Bday Party. Make a table with 5 expense categories with dollar amounts. Create a chart and type one reason why you chose the chart type.

I have made every reasonable attempt to ensure that my web page is up-to-date and does not contain links to anything that can be deemed in violation of the Meade 46-1 School District's Acceptable Use Policy.